loading
Hi
HiHiHiHiHiHiHiHiHiHiHiHi
Hi
HiHiHiHiHiHi
Hi
HiHiHiHiHiHiHiHiHiHiHiHiHiHiHiHiHiHiHiHiHiHiHiHiHi
Welcome, None (Log Out)
Current Project:
No Projects Created
Projects Inventory Help Forum

pws Help Index
Projects - Worksheets - Cable Sheet
The Cable Sheet helps you create cable, add labels, manage colors, and add them to looms

Information added here is used as the basis for Cable Labels (both in the Reports section and in the Label Maker), and the Cable Sheet Report
Adding Cables
The Cable Worksheet is broken up by your Project's Positions. Use the blank row of text boxes at bottom of every Position box to add cables.

Press enter on any of the text boxes to add your cable, or click the "Add" link at the far left

Length
The length of your cable. When printing labels, the default action is to print two labels for every cable with a length, and one label for every cable without a length. This assumes you'll need one label for each end of an item with any length, and only one label for something without length.

Cable Type
The only required field is the Cable Type. This matches to an item in the enabled Inventories.

Label
The label for you cable, used as the text on your Cable Label Report and Cable Sheet Report

Color
The color applied to your label. By default, if you don't enter a color, your cable will use the color set for it's Position. If you do enter a color here, it will override the color from the Position

Loom Name
Adding a Loom Name will create a new loom for your cables and move them into a separate Loom Section inside your Position. All cables with the same loom name are grouped together. Changing a Loom Name will move the cable to the new loom group, and if the cable was the last cable in the loom, the loom will be deleted.

Loom Ends
Looms are generally made with one end (male or female) made so the connectors are even with each other, while the opposite end has any uneveness is the cable lengths. This is so one loom can connect to another loom without fighting the loom itself. In the "Loom Ends" text box, enter which connectors you think should be even for this loom, generally either Male or Female.

Note
Any notes you'd like to add, like chain slider attachments, or specific looming directions

Attach a Circuit
Here you can attach a Circuit from the Circuiting worksheet to this cable. This lets you use the label from the Circuit worksheet instead of writing a new label here, and avoid any differences or mispellings between this worksheet and the Circuit worksheet

Use Circuit Label
If you've attached a Circuit to your Cable, check this box to use the label from the Circuit Sheet. You'll still have the option to augment the circuit label with your text from the Cable Sheet

Attach Data
You can attach Fixtures to your data cable, linking specific Fixtures and Patch information to you data homerun cables. With Fixtures linked to Cables, you can use the "Data Homerun Report" in the reports section to view a summary of your data output needs.
View the details of the "Attach Data" feature in the Attach Data Section below.

Add Univ Notes
Adds any attached universes to the 'Notes' field of your cable, for simple attaching to labels. If you repatch a fixture, the Universe Note will change as well, keeping your labels and reports up to date


Editing Cables
Edit a cable by simple changing the value in the text box and pressing enter

To sort cable, click and drag on the grab icon

Dragging a cable in or out of a loom box will add the cable to that loom or remove it

Dragging a loom or cable from one position to another will move the cable or loom to the new position


Cable Creators
Cable Creators are meant to relieve some of the repetitive parts of using the Cable Worksheet, namely creating multipart looms.

Without using a Cable Creator, if a cable loom is long enough to be broken up into multile parts, you would need to make each loom individually. The Cable Creator lets you specify a Loom Name, the length of each individual loom, and the contents of the loom, then generate the entire kit with one button.



Cable Creator Block
Each Cable Creator Block represents one Cable Creator, which would represent a single Cable Loom. Define your Cables, the Part Lengths, the Loom Name, and various other options. Each block generates one set of cables. To generate more looms, add another Cable Creator

Loom Name
Adds a Loom Name to the generated Cables. The cables will be generated in the proper loom, just like adding a standard cable with a loom name. Note that Loom Names are unique inside positions. If your loom name matches an existing Loom in the same position, then the generated cables will be added to the existing loom, instead of the Cable Creator generating a new loom.

'Save Creator' Button
Saves your work so far. This doesn't generate or change any existing cables, this is only saving the Cable Creator options. Changing a cell value, pressing Enter while in a cell, or changing any of the checkboxes or drop down menus also saves your work. The border of the creator flashes green to let you know the saving was successful

'Generate Cables' Button
Does the real work of adding the defined cables to the Cable Worksheet. To prevent accidently generating the same cables more than once, you can't generate any cables if any cables already in your Cable Worksheet were generated by that same Cable Creator. To re-generate cables, remove the old cables first.

'Remove Cables' Button
Removes any cables from your Cable Worksheet that were created by this Cable Creator. Use this before Re-Generating cables or Moving a Cable Creator. This is functionally the same as hunting down the generated cables in the Cable Worksheet and manually deleting them.

'Delete Creator' Button
Deletes the Creator, AND ANY GENERATED CABLES. If this is your only Creator in that position, a new blank form will be created to replace the deleted Creator.

'Duplicate Creator' Button
Creates a Duplicate of the Cable Creator, useful for making a second similar Cable Creator, for either the same position or another position.

'Move To Another Position' Link
Moves the Cable Creator to another Position in your Project, useful when several positions need similar looms: duplicate your first Cable Creator and Move it to the desired position. You must remove any generated cables before moving a Cable Creator

Length (Part Definitions)
In a blank Cable Creator, you'll find a row labeled "Length:", with a text box for "Part 1". This is the length of the first part of your Cable Loom, one cable will be added to your Cable Worksheet for each Part and each Cable Type (Cable type defined below). Entering a number into the "Part 1" text box will create a second text box labeled "Part 2", etc, etc. Each length much be a whole number, no words or units.

'Add Part Number to Note Field' checkbox
When generating cables, the part number will be added to the note field for the Cable

Cable Row
In a blank Cable Creator, you'll find a blank series of text boxes labeled 'Cable Type', 'Label', 'Color', 'Note', with options for 'Attach a Circuit' and 'Use Circuit Label'
One row represents one Cable Type to be added to your loom, with the various text boxes and options matching the standard Cable Worksheet rows. Adding the Cable Type to the Cable Creator is done by pressing the 'Add' button at the end of the row, or pressing 'Enter' while in any of the text boxes. Pressing the 'Generate Cables' button will add one of each Cable Type defined for each Part length defined to your Cable Worksheet.

Once a cable type has been added to your Cable Creator, it can be editing like normal, by changing the values in the text box. Changes are automatically saved once your press 'Enter' or leave the text box. While you are making changes, pressing 'Escape' restores the original value (prior to saving). Note that no existing cables in your Cable Worksheet will be changed when editing your Cable Creator cables. You should edit your Cable Creator, Remove the existing cable, then Generate the Cable Creator to remove then readd your edits.

'Cable Type' is the only required field

'Add Another Creator' Button
This button is located at the end of each position's list of Cable Creators. Clicking it will create a new blank Cable Creator for that position.


Attaching Data to Cables
Clicking the "Add" or "Data" link in the "Attach Data" column opens the Fixture Selection window, where you attach specific fixtures to your cable. This enables reports like the Data Homerun report, which maps ports on a CPC or sneaksnake, as well as certain Labelmaker options ('First Fixture' reports, DMX Chain Colors, etc)

Select the First Fixture in your cable chain (whichever fixture the data homerun physcially plugs into). If your cable is a multi-universe cable, like a Sneaksnake or a 4-Port CPC, select the first fixture in each universe. You can deselect a fixture by clicking again.

Click the "Save Selection" button to save your work. The window will close add the "Add" button (or "Data" button in blank rows) will change to show the first universe in your selection. To cancel any changes you've made, simply close the window without clicking the Save button, either with the 'X' in the top right corner or by clicking outside the Attach window.

Best Practices
You should attach your fixtures to each cable and adapter in the data run. Certain features use the attachments as a guide on how your data system will be setup

Some duplicates can be automatically hidden in the Data Homerun report, by matching Cable Generator info or by matching Cable Types and Labels. However, some duplicate information may still make it to the reports, if you have two different types of cables or adapters in the data run.
There is an option to eliminate these duplicates on the Data Homerun report screen, but there are some potential errors that can be introduced. If a fixture requires more than one data cable (certain Followspot fixtures, or Dual-Input fixtures with DMX movement and sACN pixel information, for example) will have their second cable hidden. In these cases it's best to either accept the duplicates or only attach the fixtures to one cable or adapter per data run.